﻿/***********************************************************************************************************************************
 *    Name: Performance_Counters.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary: See if the performance counters are installed.
**/
SELECT  ServerName = @@SERVERNAME,
        ProductVersion = DBAdmin.ProductVersion(),
        performance_counters = COUNT(*)
FROM    sys.dm_os_performance_counters;
GO